SELECT *
FROM london_stages
WHERE eventid IN (42974, 42977, 42979, 42982, 42986, 42988, 42991, 42997, 43001, 43006, 43050, 43054, 43059, 43086, 43295, 46106, 46908, 46912, 46918, 46924, 46930, 46976, 46990, 47014, 47038, 47052, 50704, 50709, 50712, 50717, 50722, 50726, 51047)
GROUP BY eventid
ORDER BY eventdate ASC
OPTION